﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$ForumDBConnection$" type="$ForumDBType$">
  <Field name="lastPostBy" type="User" />
  <Field name="lastPostDate" type="Date" />
  <Field name="totalPosts" type="Integer" />
  <SqlStatement hasResults="false">
    UPDATE ForumThreads SET 
      lastPostById=@lastPostById,
      lastPostByName=@lastPostByName,
      lastPostDate=@lastPostDate,
      totalPosts=totalPosts+1
    WHERE id=@id
  </SqlStatement>
  <Param name="id" type="UniqueIdentifier"/>
  <Param name="lastPostBy.id" dbName="lastPostById" type="UniqueIdentifier" />
  <Param name="lastPostBy.userName" dbName="lastPostByName" type="VarChar" />
  <Param name="lastPostDate" type="DateTime" />
</DbDataRequest>